<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="gm143896">pg_description</title><body><p>The <codeph>pg_description</codeph> system catalog table stores optional descriptions (comments)
      for each database object. Descriptions can be manipulated with the <codeph>COMMENT</codeph>
      command and viewed with <codeph>psql</codeph>'s <codeph>\d</codeph> meta-commands.
      Descriptions of many built-in system objects are provided in the initial contents of
        <codeph>pg_description</codeph>. See also <xref href="pg_shdescription.xml#topic1"
        >pg_shdescription</xref>, which performs a similar function for descriptions involving
      objects that are shared across a Greenplum system.</p><table id="gm143898"><title>pg_catalog.pg_description</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>objoid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">any OID column</entry><entry colname="col4">The OID of the object this description pertains
to.</entry></row><row><entry colname="col1"><codeph>classoid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_class.oid</entry><entry colname="col4">The OID of the system catalog this object appears
in</entry></row><row><entry colname="col1"><codeph>objsubid </codeph></entry><entry colname="col2">int4</entry><entry colname="col3"/><entry colname="col4">For a comment on a table column, this is the
column number. For all other object types, this column is zero.</entry></row><row><entry colname="col1"><codeph>description </codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">Arbitrary text that serves as the description
of this object.</entry></row></tbody></tgroup></table></body></topic>